package com.shiguiwu.springboot3.mapper;

import com.shiguiwu.springboot3.entity.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.CommonMapper;

import java.util.List;

/**
 * @description: user
 * @author: stone
 * @date: Created by 2023/7/2 15:26
 * @version: 1.0.0
 * @pakeage: com.shiguiwu.springboot3
 */
public interface UserMapper extends CommonMapper<User> {

    int queryTest();


    @Insert("insert into a(a,b) values('insert','read') ")
    int saveA(@Param("list") List<String> a, @Param("b") Integer b);

    @Select("select u.name from t_user u left join aaaa a on u.age = a.age")
    List<String> selectByCC();

    List<Integer> selectByBB();
}
